TDbCommand failed to execute the query SQL "SELECT count(id) FROM figure WHERE is_duplicate = 0 AND is_deleted = 0 AND slug != '' AND (category = 'Toy'sworks Collection Niitengo premium Red Faction' OR classification LIKE '%Toy'sworks Collection Niitengo premium Red Faction%')": SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'sworks Collection Niitengo premium Red Faction' OR classification LIKE '%Toy'swo' at line 1
${PradoFramework}/Data/TDbCommand.php (279)
0268: } else {
0269: $this->_statement = $this->getConnection()->getPdoInstance()->query($this->getText());
0270: }
0271: $result = $this->_statement->fetchColumn();
0272: $this->_statement->closeCursor();
0273: if (is_resource($result) && get_resource_type($result) === 'stream') {
0274: return stream_get_contents($result);
0275: } else {
0276: return $result;
0277: }
0278: } catch (Exception $e) {
0279: throw new TDbException('dbcommand_query_failed', $e->getMessage(), $this->getDebugStatementText());
0280: }
0281: }
0282:
0283: /**
0284: * Executes the SQL statement and returns the first column of the result.
0285: * This is a convenient method of {@link query} when only the first column of data is needed.
0286: * Note, the column returned will contain the first element in each row of result.
0287: * @throws TDbException execution failed
0288: * @return array the first column of the query result. Empty array if no result.
0289: * @since 3.1.2
0290: */
0291: public function queryColumn()
#0 ${DocumentRoot}/protected/pages/product.php(439): Prado\Data\TDbCommand->queryScalar()
#1 ${DocumentRoot}/protected/pages/product.php(63): product->getListProduct()
#2 ${DocumentRoot}/protected/pages/product.php(21): product->loadData()
#3 ${PradoFramework}/Web/UI/TControl.php(1375): product->onLoad(NULL)
#4 ${PradoFramework}/Web/UI/TPage.php(241): Prado\Web\UI\TControl->loadRecursive()
#5 ${PradoFramework}/Web/UI/TPage.php(221): Prado\Web\UI\TPage->processNormalRequest(Object(Prado\Web\UI\THtmlWriter))
#6 ${PradoFramework}/Web/Services/TPageService.php(547): Prado\Web\UI\TPage->run(Object(Prado\Web\UI\THtmlWriter))
#7 ${PradoFramework}/Web/Services/TPageService.php(465): Prado\Web\Services\TPageService->runPage(Object(product), Array)
#8 ${PradoFramework}/TApplication.php(1245): Prado\Web\Services\TPageService->run()
#9 ${PradoFramework}/TApplication.php(386): Prado\TApplication->runService()
#10 ${DocumentRoot}/index.php(23): Prado\TApplication->run()
#11 {main}